Computer Stock Check

What is this?

This document describes how to perform a computer stock check with Anchor Distributors.  This method of performing a stock check is primarily used by Bookstore Manager’s stock check function.

What is a computer stock check?

A computer stock check is a stock check performed via dial up modem.  The client computer will dial into the host computer, issue a request and receive a response all on one call.  The client may issue multiple requests before hanging up and effectively terminating the stock check session.

How do I send and receive Stock Checks?

Use the following number to perform computer stock checks.

877-600-4689

A transmission with the computer stock check system should go as follows:

1) Send customer an ASC(5)
2) Receive from customer the isbn request which has the following format:
   
ASC(1)
   
ISBN or SPEEDY CODE (10 characters)
   
!
   
ASC(7)
3) Send Customer an ASC(6)
4) Look up ISBN or Speedy in Oracle
5) Send data record back which has the following format:

Chr(2)
ISBN
Title
Price
BindingCode
OnHand
StockStatus   “ = active,
“OS” = out of stock,
“DT” = discontinuing,
“NC” = not carried,
“OP” = out of print,
“NA” = not yet available,
“CI” = can not identify
"00000"
Space(2)
"00000"
Space(2)
"00000"
Space(2)
"00000"
Space(2)
"00000"
Space(2)
ErrorCode
CheckSum

6) Loop back to test for another one
7) If no more ISBN records then hang up

What codes are valid for lookups?

We accept ISBN, EAN13, UPC, or Speedy codes for lookup strings for a computer stock check.